SQL MIN and SQL MAX

SQL Functions MIN() and MAX() Description

The MIN() function returns the smallest value of the selected column.

The MAX() function returns the largest value of the selected column.

MIN() Syntax

SELECT MIN(column_name) 
FROM table_name 
WHERE condition

MAX() Syntax

SELECT MAX(column_name) 
FROM table_name 
WHERE condition

Demonstration database

The following is a sample from the "Products" ("Products") table of the "Northwind" database:

MIN() Example

The following SQL statement determines the price of the cheapest product:

Run SQLSELECT MIN(Price) AS SmallestPrice 
FROM Products

MAX() Example

The following SQL statement finds the price of the most expensive product:

Run SQLSELECT MAX(Price) AS LargestPrice 
FROM Products